﻿using System;
using System.Collections.Generic;
using System.Data.Linq.Mapping;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace WindowsFormsApp1
{
    [Table(Name = "PO_Podetails")]
    public class clsPODetails
    {
        [Column(IsPrimaryKey =true)]
        public int ID { get; set; }

        [Column]
        public String cPOID { get; set; }

        [Column]
        public String cInvCode { get; set; }

        [Column]
        public decimal iQuantity { get; set; }

        [Column]
        public decimal iNum { get; set; }

        [Column]
        public decimal iQuotedPrice { get; set; }

        [Column]
        public decimal iUnitPrice { get; set; }

        [Column]
        public decimal iMoney { get; set; }

        [Column]
        public decimal iTax { get; set; }

        [Column]
        public decimal iSum { get; set; }

        [Column]
        public decimal iDisCount { get; set; }

        [Column]
        public decimal iNatUnitPrice { get; set; }

        [Column]
        public decimal iNatMoney { get; set; }

        [Column]
        public decimal iNatTax { get; set; }

        [Column]
        public decimal iNatSum { get; set; }

        [Column]
        public decimal iNatDisCount { get; set; }

        [Column]
        public DateTime? dArriveDate { get; set; }

        [Column]
        public decimal iReceivedQTY { get; set; }

        [Column]
        public decimal iReceivedNum { get; set; }

        [Column]
        public decimal iReceivedMoney { get; set; }

        [Column]
        public decimal iInvQTY { get; set; }

        [Column]
        public decimal iInvNum { get; set; }

        [Column]
        public decimal iInvMoney { get; set; }

        [Column]
        public String cFree1 { get; set; }

        [Column]
        public String cFree2 { get; set; }

        [Column]
        public decimal iNatInvMoney { get; set; }

        [Column]
        public decimal iOriTotal { get; set; }

        [Column]
        public decimal iTotal { get; set; }

        [Column]
        public decimal iPerTaxRate { get; set; }

        [Column]
        public String cDefine22 { get; set; }

        [Column]
        public String cDefine23 { get; set; }

        [Column]
        public String cDefine24 { get; set; }

        [Column]
        public String cDefine25 { get; set; }

        [Column]
        public decimal cDefine26 { get; set; }

        [Column]
        public decimal cDefine27 { get; set; }

        [Column]
        public int iflag { get; set; }

        [Column]
        public String cItemCode { get; set; }

        [Column]
        public String cItem_class { get; set; }

        [Column]
        public int PPCIds { get; set; }

        [Column]
        public String cItemName { get; set; }

        [Column]
        public String cFree3 { get; set; }

        [Column]
        public String cFree4 { get; set; }

        [Column]
        public String cFree5 { get; set; }

        [Column]
        public String cFree6 { get; set; }

        [Column]
        public String cFree7 { get; set; }

        [Column]
        public String cFree8 { get; set; }

        [Column]
        public String cFree9 { get; set; }

        [Column]
        public String cFree10 { get; set; }

        [Column]
        public int bGsp { get; set; }

        [Column]
        public int POID { get; set; }

        [Column]
        public String cUnitID { get; set; }

        [Column]
        public decimal iTaxPrice { get; set; }

        [Column]
        public decimal iArrQTY { get; set; }

        [Column]
        public decimal iArrNum { get; set; }

        [Column]
        public decimal iArrMoney { get; set; }

        [Column]
        public decimal iNatArrMoney { get; set; }

        [Column]
        public int iAppIds { get; set; }

        [Column]
        public String cDefine28 { get; set; }

        [Column]
        public String cDefine29 { get; set; }

        [Column]
        public String cDefine30 { get; set; }

        [Column]
        public String cDefine31 { get; set; }

        [Column]
        public String cDefine32 { get; set; }

        [Column]
        public String cDefine33 { get; set; }

        [Column]
        public int cDefine34 { get; set; }

        [Column]
        public int cDefine35 { get; set; }

        [Column]
        public DateTime? cDefine36 { get; set; }

        [Column]
        public DateTime? cDefine37 { get; set; }

        [Column]
        public int iSOsID { get; set; }

        [Column]
        public int bTaxCost { get; set; }

        [Column]
        public String cSource { get; set; }

        [Column]
        public String cbCloser { get; set; }

        [Column]
        public int iPPartId { get; set; }

        [Column]
        public decimal iPQuantity { get; set; }

        [Column]
        public int iPTOSeq { get; set; }

        [Column]
        public int SoType { get; set; }

        [Column]
        public String SoDId { get; set; }

        [Column]
        public string ContractRowGUID { get; set; }

        [Column]
        public String cupsocode { get; set; }

        [Column]
        public decimal iInvMPCost { get; set; }

        [Column]
        public String ContractCode { get; set; }

        [Column]
        public String ContractRowNo { get; set; }

        [Column]
        public decimal fPoValidQuantity { get; set; }

        [Column]
        public decimal fPoValidNum { get; set; }

        [Column]
        public decimal fPoArrQuantity { get; set; }

        [Column]
        public decimal fPoArrNum { get; set; }

        [Column]
        public decimal fPoRetQuantity { get; set; }

        [Column]
        public decimal fPoRetNum { get; set; }

        [Column]
        public decimal fPoRefuseQuantity { get; set; }

        [Column]
        public decimal fPoRefuseNum { get; set; }

        [Column]
        public string dUfts { get; set; }

        [Column]
        public int iorderdid { get; set; }

        [Column]
        public int iordertype { get; set; }

        [Column]
        public String csoordercode { get; set; }

        [Column]
        public int iorderseq { get; set; }

        [Column]
        public DateTime? cbCloseTime { get; set; }

        [Column]
        public DateTime? cbCloseDate { get; set; }

        [Column]
        public String cBG_ItemCode { get; set; }

        [Column]
        public String cBG_ItemName { get; set; }

        [Column]
        public String cBG_CaliberKey1 { get; set; }

        [Column]
        public String cBG_CaliberKeyName1 { get; set; }

        [Column]
        public String cBG_CaliberKey2 { get; set; }

        [Column]
        public String cBG_CaliberKeyName2 { get; set; }

        [Column]
        public String cBG_CaliberKey3 { get; set; }

        [Column]
        public String cBG_CaliberKeyName3 { get; set; }

        [Column]
        public String cBG_CaliberCode1 { get; set; }

        [Column]
        public String cBG_CaliberName1 { get; set; }

        [Column]
        public String cBG_CaliberCode2 { get; set; }

        [Column]
        public String cBG_CaliberName2 { get; set; }

        [Column]
        public String cBG_CaliberCode3 { get; set; }

        [Column]
        public String cBG_CaliberName3 { get; set; }

        [Column]
        public int iBG_Ctrl { get; set; }

        [Column]
        public String cBG_Auditopinion { get; set; }

        [Column]
        public decimal fexquantity { get; set; }

        [Column]
        public decimal fexnum { get; set; }

        [Column]
        public int ivouchrowno { get; set; }

        [Column]
        public String cBG_CaliberKey4 { get; set; }

        [Column]
        public String cBG_CaliberKeyName4 { get; set; }

        [Column]
        public String cBG_CaliberKey5 { get; set; }

        [Column]
        public String cBG_CaliberKeyName5 { get; set; }

        [Column]
        public String cBG_CaliberKey6 { get; set; }

        [Column]
        public String cBG_CaliberKeyName6 { get; set; }

        [Column]
        public String cBG_CaliberCode4 { get; set; }

        [Column]
        public String cBG_CaliberName4 { get; set; }

        [Column]
        public String cBG_CaliberCode5 { get; set; }

        [Column]
        public String cBG_CaliberName5 { get; set; }

        [Column]
        public String cBG_CaliberCode6 { get; set; }

        [Column]
        public String cBG_CaliberName6 { get; set; }

        [Column]
        public String csocode { get; set; }

        [Column]
        public int irowno { get; set; }

        [Column]
        public decimal freceivedqty { get; set; }

        [Column]
        public decimal freceivednum { get; set; }

        [Column]
        public String cxjspdids { get; set; }

        [Column]
        public String cbMemo { get; set; }

        [Column]
        public String cbsysbarcode { get; set; }

        [Column]
        public String planlotnumber { get; set; }

        [Column]
        public int bgift { get; set; }

        [Column]
        public String cFactoryCode { get; set; }

    }
}
